<%@ page session="true" contentType="text/html; charset=UTF-8" %>
 <%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>
 <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<c:set var="title01" scope="session">充值报表</c:set>
 <jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver"
                   jdbcUrl="jdbc:mysql://localhost/kodak_uat?user=kodak_admin&password=lc541116"
                   catalogUri="/WEB-INF/queries/job.xml">
select {[Measures].[value]} on columns,
{([Time].[All Periods])} on rows
  from job
  where [Class].[Pay]

</jp:mondrianQuery>